﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="DatabaseConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="DatabaseConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ManagementSystem.Properties.Settings.GlobalReference.Default.DatabaseConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LessonTableAdapter" GeneratorDataComponentClassName="LessonTableAdapter" Name="Lesson" UserDataComponentName="LessonTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Settings)" DbObjectName="dbo.Lesson" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Lesson] WHERE (([Lessond_ID] = @Original_Lessond_ID) AND ([Topic] = @Original_Topic) AND ([Date] = @Original_Date) AND ((@IsNull_Comment = 1 AND [Comment] IS NULL) OR ([Comment] = @Original_Comment)) AND ([Subject_ID] = @Original_Subject_ID) AND ([User_ID] = @Original_User_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Lessond_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lessond_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Topic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Topic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Comment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Subject_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Subject_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Lesson] ([Topic], [Date], [Descripton], [Comment], [Subject_ID], [User_ID]) VALUES (@Topic, @Date, @Descripton, @Comment, @Subject_ID, @User_ID);
SELECT Lessond_ID, Topic, Date, Descripton, Comment, Subject_ID, User_ID FROM Lesson WHERE (Lessond_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Topic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Topic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripton" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripton" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Subject_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Subject_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Lessond_ID, Topic, Date, Descripton, Comment, Subject_ID, User_ID FROM dbo.Lesson</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Lesson] SET [Topic] = @Topic, [Date] = @Date, [Descripton] = @Descripton, [Comment] = @Comment, [Subject_ID] = @Subject_ID, [User_ID] = @User_ID WHERE (([Lessond_ID] = @Original_Lessond_ID) AND ([Topic] = @Original_Topic) AND ([Date] = @Original_Date) AND ((@IsNull_Comment = 1 AND [Comment] IS NULL) OR ([Comment] = @Original_Comment)) AND ([Subject_ID] = @Original_Subject_ID) AND ([User_ID] = @Original_User_ID));
SELECT Lessond_ID, Topic, Date, Descripton, Comment, Subject_ID, User_ID FROM Lesson WHERE (Lessond_ID = @Lessond_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Topic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Topic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descripton" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descripton" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Subject_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Subject_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Lessond_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lessond_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Topic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Topic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Date" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Date" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Comment" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Subject_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Subject_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Lessond_ID" ColumnName="Lessond_ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Lessond_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Lessond_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Lessond_ID" DataSetColumn="Lessond_ID" />
              <Mapping SourceColumn="Topic" DataSetColumn="Topic" />
              <Mapping SourceColumn="Date" DataSetColumn="Date" />
              <Mapping SourceColumn="Descripton" DataSetColumn="Descripton" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="Subject_ID" DataSetColumn="Subject_ID" />
              <Mapping SourceColumn="User_ID" DataSetColumn="User_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="StudentTableAdapter" GeneratorDataComponentClassName="StudentTableAdapter" Name="Student" UserDataComponentName="StudentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Settings)" DbObjectName="dbo.Student" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Student] WHERE (([Student_ID] = @Original_Student_ID) AND ([firstName] = @Original_firstName) AND ([lastName] = @Original_lastName) AND ([speciality] = @Original_speciality) AND ([studentGroup] = @Original_studentGroup) AND ([identityCode] = @Original_identityCode) AND ([user_ID] = @Original_user_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Student_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_firstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="firstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_lastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_speciality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="speciality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_studentGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="studentGroup" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_identityCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="identityCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_user_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Student] ([firstName], [lastName], [speciality], [studentGroup], [identityCode], [comment], [user_ID]) VALUES (@firstName, @lastName, @speciality, @studentGroup, @identityCode, @comment, @user_ID);
SELECT Student_ID, firstName, lastName, speciality, studentGroup, identityCode, comment, user_ID FROM Student WHERE (Student_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@firstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="firstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@speciality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="speciality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@studentGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="studentGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@identityCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="identityCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@comment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Student_ID, firstName, lastName, speciality, studentGroup, identityCode, comment, user_ID FROM dbo.Student</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Student] SET [firstName] = @firstName, [lastName] = @lastName, [speciality] = @speciality, [studentGroup] = @studentGroup, [identityCode] = @identityCode, [comment] = @comment, [user_ID] = @user_ID WHERE (([Student_ID] = @Original_Student_ID) AND ([firstName] = @Original_firstName) AND ([lastName] = @Original_lastName) AND ([speciality] = @Original_speciality) AND ([studentGroup] = @Original_studentGroup) AND ([identityCode] = @Original_identityCode) AND ([user_ID] = @Original_user_ID));
SELECT Student_ID, firstName, lastName, speciality, studentGroup, identityCode, comment, user_ID FROM Student WHERE (Student_ID = @Student_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@firstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="firstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@speciality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="speciality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@studentGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="studentGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@identityCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="identityCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@comment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Student_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_firstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="firstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_lastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_speciality" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="speciality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_studentGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="studentGroup" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_identityCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="identityCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_user_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Student_ID" ColumnName="Student_ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Student_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Student_ID" DataSetColumn="Student_ID" />
              <Mapping SourceColumn="firstName" DataSetColumn="firstName" />
              <Mapping SourceColumn="lastName" DataSetColumn="lastName" />
              <Mapping SourceColumn="speciality" DataSetColumn="speciality" />
              <Mapping SourceColumn="studentGroup" DataSetColumn="studentGroup" />
              <Mapping SourceColumn="identityCode" DataSetColumn="identityCode" />
              <Mapping SourceColumn="comment" DataSetColumn="comment" />
              <Mapping SourceColumn="user_ID" DataSetColumn="user_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Student_In_LessonTableAdapter" GeneratorDataComponentClassName="Student_In_LessonTableAdapter" Name="Student_In_Lesson" UserDataComponentName="Student_In_LessonTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Settings)" DbObjectName="dbo.Student_In_Lesson" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Student_In_Lesson] WHERE (([Student_In_lesson_ID] = @Original_Student_In_lesson_ID) AND ([Student_ID] = @Original_Student_ID) AND ([Lesson_ID] = @Original_Lesson_ID) AND ([User_ID] = @Original_User_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Student_In_lesson_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_In_lesson_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Student_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Lesson_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lesson_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Student_In_Lesson] ([Student_ID], [Lesson_ID], [Comment], [User_ID]) VALUES (@Student_ID, @Lesson_ID, @Comment, @User_ID);
SELECT Student_In_lesson_ID, Student_ID, Lesson_ID, Comment, User_ID FROM Student_In_Lesson WHERE (Student_In_lesson_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Student_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Lesson_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lesson_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Student_In_lesson_ID, Student_ID, Lesson_ID, Comment, User_ID FROM dbo.Student_In_Lesson</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Student_In_Lesson] SET [Student_ID] = @Student_ID, [Lesson_ID] = @Lesson_ID, [Comment] = @Comment, [User_ID] = @User_ID WHERE (([Student_In_lesson_ID] = @Original_Student_In_lesson_ID) AND ([Student_ID] = @Original_Student_ID) AND ([Lesson_ID] = @Original_Lesson_ID) AND ([User_ID] = @Original_User_ID));
SELECT Student_In_lesson_ID, Student_ID, Lesson_ID, Comment, User_ID FROM Student_In_Lesson WHERE (Student_In_lesson_ID = @Student_In_lesson_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Student_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Lesson_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lesson_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Student_In_lesson_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_In_lesson_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Student_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Lesson_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Lesson_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Student_In_lesson_ID" ColumnName="Student_In_lesson_ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Student_In_lesson_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Student_In_lesson_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Student_In_lesson_ID" DataSetColumn="Student_In_lesson_ID" />
              <Mapping SourceColumn="Student_ID" DataSetColumn="Student_ID" />
              <Mapping SourceColumn="Lesson_ID" DataSetColumn="Lesson_ID" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="User_ID" DataSetColumn="User_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Student_In_SubjectTableAdapter" GeneratorDataComponentClassName="Student_In_SubjectTableAdapter" Name="Student_In_Subject" UserDataComponentName="Student_In_SubjectTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Settings)" DbObjectName="dbo.Student_In_Subject" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Student_In_Subject] WHERE (([Student_In_Subject] = @Original_Student_In_Subject) AND ([Student_ID] = @Original_Student_ID) AND ([Subject_ID] = @Original_Subject_ID) AND ([User_ID] = @Original_User_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Student_In_Subject" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_In_Subject" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Student_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Subject_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Subject_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Student_In_Subject] ([Student_ID], [Subject_ID], [Comment], [User_ID]) VALUES (@Student_ID, @Subject_ID, @Comment, @User_ID);
SELECT Student_In_Subject, Student_ID, Subject_ID, Comment, User_ID FROM Student_In_Subject WHERE (Student_In_Subject = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Student_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Subject_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Subject_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Student_In_Subject, Student_ID, Subject_ID, Comment, User_ID FROM dbo.Student_In_Subject</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Student_In_Subject] SET [Student_ID] = @Student_ID, [Subject_ID] = @Subject_ID, [Comment] = @Comment, [User_ID] = @User_ID WHERE (([Student_In_Subject] = @Original_Student_In_Subject) AND ([Student_ID] = @Original_Student_ID) AND ([Subject_ID] = @Original_Subject_ID) AND ([User_ID] = @Original_User_ID));
SELECT Student_In_Subject, Student_ID, Subject_ID, Comment, User_ID FROM Student_In_Subject WHERE (Student_In_Subject = @Student_In_Subject)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Student_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Subject_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Subject_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Student_In_Subject" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_In_Subject" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Student_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Student_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Subject_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Subject_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Student_In_Subject" ColumnName="Student_In_Subject" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Student_In_Subject" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Student_In_Subject" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Student_In_Subject" DataSetColumn="Student_In_Subject" />
              <Mapping SourceColumn="Student_ID" DataSetColumn="Student_ID" />
              <Mapping SourceColumn="Subject_ID" DataSetColumn="Subject_ID" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="User_ID" DataSetColumn="User_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SubjectTableAdapter" GeneratorDataComponentClassName="SubjectTableAdapter" Name="Subject" UserDataComponentName="SubjectTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Settings)" DbObjectName="dbo.Subject" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Subject] WHERE (([Subject_ID] = @Original_Subject_ID) AND ([Name] = @Original_Name) AND ([EAP] = @Original_EAP) AND ([SubjectCode] = @Original_SubjectCode) AND ([Language] = @Original_Language) AND ([User_ID] = @Original_User_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Subject_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Subject_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EAP" Precision="16" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="EAP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SubjectCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SubjectCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Language" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Subject] ([Name], [EAP], [SubjectCode], [Language], [Comment], [User_ID]) VALUES (@Name, @EAP, @SubjectCode, @Language, @Comment, @User_ID);
SELECT Subject_ID, Name, EAP, SubjectCode, Language, Comment, User_ID FROM Subject WHERE (Subject_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EAP" Precision="16" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="EAP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SubjectCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SubjectCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Language" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Subject_ID, Name, EAP, SubjectCode, Language, Comment, User_ID FROM dbo.Subject</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Subject] SET [Name] = @Name, [EAP] = @EAP, [SubjectCode] = @SubjectCode, [Language] = @Language, [Comment] = @Comment, [User_ID] = @User_ID WHERE (([Subject_ID] = @Original_Subject_ID) AND ([Name] = @Original_Name) AND ([EAP] = @Original_EAP) AND ([SubjectCode] = @Original_SubjectCode) AND ([Language] = @Original_Language) AND ([User_ID] = @Original_User_ID));
SELECT Subject_ID, Name, EAP, SubjectCode, Language, Comment, User_ID FROM Subject WHERE (Subject_ID = @Subject_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@EAP" Precision="16" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="EAP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SubjectCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SubjectCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Language" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Subject_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Subject_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_EAP" Precision="16" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="EAP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SubjectCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SubjectCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Language" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Subject_ID" ColumnName="Subject_ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Subject_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Subject_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Subject_ID" DataSetColumn="Subject_ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="EAP" DataSetColumn="EAP" />
              <Mapping SourceColumn="SubjectCode" DataSetColumn="SubjectCode" />
              <Mapping SourceColumn="Language" DataSetColumn="Language" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
              <Mapping SourceColumn="User_ID" DataSetColumn="User_ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserTableAdapter" GeneratorDataComponentClassName="UserTableAdapter" Name="User" UserDataComponentName="UserTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Settings)" DbObjectName="dbo.[User]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[User] WHERE (([User_ID] = @Original_User_ID) AND ([firstName] = @Original_firstName) AND ([lastName] = @Original_lastName) AND ([userName] = @Original_userName) AND ([password] = @Original_password))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_firstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="firstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_lastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_userName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="userName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[User] ([firstName], [lastName], [userName], [password]) VALUES (@firstName, @lastName, @userName, @password);
SELECT User_ID, firstName, lastName, userName, password FROM [User] WHERE (User_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@firstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="firstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@userName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="userName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT User_ID, firstName, lastName, userName, password FROM dbo.[User]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[User] SET [firstName] = @firstName, [lastName] = @lastName, [userName] = @userName, [password] = @password WHERE (([User_ID] = @Original_User_ID) AND ([firstName] = @Original_firstName) AND ([lastName] = @Original_lastName) AND ([userName] = @Original_userName) AND ([password] = @Original_password));
SELECT User_ID, firstName, lastName, userName, password FROM [User] WHERE (User_ID = @User_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@firstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="firstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@lastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lastName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@userName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="userName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_User_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_firstName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="firstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_lastName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="lastName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_userName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="userName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="User_ID" ColumnName="User_ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@User_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="User_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="User_ID" DataSetColumn="User_ID" />
              <Mapping SourceColumn="firstName" DataSetColumn="firstName" />
              <Mapping SourceColumn="lastName" DataSetColumn="lastName" />
              <Mapping SourceColumn="userName" DataSetColumn="userName" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TundTableAdapter" GeneratorDataComponentClassName="TundTableAdapter" Name="Tund" UserDataComponentName="TundTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Settings)" DbObjectName="dbo.Tund" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Tund] WHERE (([Tund_ID] = @Original_Tund_ID) AND ((@IsNull_Aine = 1 AND [Aine] IS NULL) OR ([Aine] = @Original_Aine)) AND ((@IsNull_Teema = 1 AND [Teema] IS NULL) OR ([Teema] = @Original_Teema)) AND ((@IsNull_Kirjeldus = 1 AND [Kirjeldus] IS NULL) OR ([Kirjeldus] = @Original_Kirjeldus)) AND ((@IsNull_Kuupäev = 1 AND [Kuupäev] IS NULL) OR ([Kuupäev] = @Original_Kuupäev)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Tund_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tund_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Aine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Aine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Aine" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Aine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Teema" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Teema" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Teema" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Teema" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Kirjeldus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kirjeldus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Kirjeldus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kirjeldus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Kuupäev" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kuupäev" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Kuupäev" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Kuupäev" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Tund] ([Aine], [Teema], [Kirjeldus], [Kommentaar], [Kuupäev]) VALUES (@Aine, @Teema, @Kirjeldus, @Kommentaar, @Kuupäev);
SELECT Tund_ID, Aine, Teema, Kirjeldus, Kommentaar, Kuupäev FROM Tund WHERE (Tund_ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Aine" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Aine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Teema" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Teema" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Kirjeldus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kirjeldus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Kommentaar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kommentaar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Kuupäev" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Kuupäev" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Tund_ID, Aine, Teema, Kirjeldus, Kommentaar, Kuupäev FROM dbo.Tund</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Tund] SET [Aine] = @Aine, [Teema] = @Teema, [Kirjeldus] = @Kirjeldus, [Kommentaar] = @Kommentaar, [Kuupäev] = @Kuupäev WHERE (([Tund_ID] = @Original_Tund_ID) AND ((@IsNull_Aine = 1 AND [Aine] IS NULL) OR ([Aine] = @Original_Aine)) AND ((@IsNull_Teema = 1 AND [Teema] IS NULL) OR ([Teema] = @Original_Teema)) AND ((@IsNull_Kirjeldus = 1 AND [Kirjeldus] IS NULL) OR ([Kirjeldus] = @Original_Kirjeldus)) AND ((@IsNull_Kuupäev = 1 AND [Kuupäev] IS NULL) OR ([Kuupäev] = @Original_Kuupäev)));
SELECT Tund_ID, Aine, Teema, Kirjeldus, Kommentaar, Kuupäev FROM Tund WHERE (Tund_ID = @Tund_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Aine" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Aine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Teema" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Teema" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Kirjeldus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kirjeldus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Kommentaar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kommentaar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Kuupäev" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Kuupäev" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Tund_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tund_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Aine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Aine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Aine" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Aine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Teema" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Teema" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Teema" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Teema" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Kirjeldus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kirjeldus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Kirjeldus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Kirjeldus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Kuupäev" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kuupäev" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Kuupäev" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Kuupäev" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Tund_ID" ColumnName="Tund_ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Tund_ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Tund_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Tund_ID" DataSetColumn="Tund_ID" />
              <Mapping SourceColumn="Aine" DataSetColumn="Aine" />
              <Mapping SourceColumn="Teema" DataSetColumn="Teema" />
              <Mapping SourceColumn="Kirjeldus" DataSetColumn="Kirjeldus" />
              <Mapping SourceColumn="Kommentaar" DataSetColumn="Kommentaar" />
              <Mapping SourceColumn="Kuupäev" DataSetColumn="Kuupäev" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HinneTableAdapter" GeneratorDataComponentClassName="HinneTableAdapter" Name="Hinne" UserDataComponentName="HinneTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseConnectionString (Settings)" DbObjectName="dbo.Hinne" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Hinne] WHERE (((@IsNull_Eesnimi = 1 AND [Eesnimi] IS NULL) OR ([Eesnimi] = @Original_Eesnimi)) AND ((@IsNull_Perenimi = 1 AND [Perenimi] IS NULL) OR ([Perenimi] = @Original_Perenimi)) AND ((@IsNull_Aine = 1 AND [Aine] IS NULL) OR ([Aine] = @Original_Aine)) AND ((@IsNull_Hinne1 = 1 AND [Hinne1] IS NULL) OR ([Hinne1] = @Original_Hinne1)) AND ((@IsNull_Hinne2 = 1 AND [Hinne2] IS NULL) OR ([Hinne2] = @Original_Hinne2)) AND ((@IsNull_Hinne3 = 1 AND [Hinne3] IS NULL) OR ([Hinne3] = @Original_Hinne3)) AND ((@IsNull_Hinne4 = 1 AND [Hinne4] IS NULL) OR ([Hinne4] = @Original_Hinne4)) AND ((@IsNull_Hinne5 = 1 AND [Hinne5] IS NULL) OR ([Hinne5] = @Original_Hinne5)) AND ((@IsNull_Hinne6 = 1 AND [Hinne6] IS NULL) OR ([Hinne6] = @Original_Hinne6)) AND ((@IsNull_Hinne7 = 1 AND [Hinne7] IS NULL) OR ([Hinne7] = @Original_Hinne7)) AND ((@IsNull_Hinne8 = 1 AND [Hinne8] IS NULL) OR ([Hinne8] = @Original_Hinne8)) AND ((@IsNull_Hinne9 = 1 AND [Hinne9] IS NULL) OR ([Hinne9] = @Original_Hinne9)) AND ((@IsNull_Hinne10 = 1 AND [Hinne10] IS NULL) OR ([Hinne10] = @Original_Hinne10)) AND ((@IsNull_Kokku = 1 AND [Kokku] IS NULL) OR ([Kokku] = @Original_Kokku)) AND ([ID] = @Original_ID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Eesnimi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Eesnimi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Eesnimi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Eesnimi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Perenimi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Perenimi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Perenimi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Perenimi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Aine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Aine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Aine" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Aine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne1" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne2" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne3" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne4" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne5" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne5" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne5" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne6" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne6" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne6" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne6" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne7" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne7" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne7" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne7" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne8" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne8" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne8" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne8" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne9" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne9" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne9" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne9" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne10" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne10" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne10" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne10" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Kokku" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kokku" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kokku" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kokku" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Hinne] ([Eesnimi], [Perenimi], [Aine], [Hinne1], [Hinne2], [Hinne3], [Hinne4], [Hinne5], [Hinne6], [Hinne7], [Hinne8], [Hinne9], [Hinne10]) VALUES (@Eesnimi, @Perenimi, @Aine, @Hinne1, @Hinne2, @Hinne3, @Hinne4, @Hinne5, @Hinne6, @Hinne7, @Hinne8, @Hinne9, @Hinne10);
SELECT Eesnimi, Perenimi, Aine, Hinne1, Hinne2, Hinne3, Hinne4, Hinne5, Hinne6, Hinne7, Hinne8, Hinne9, Hinne10, Kokku, ID FROM Hinne WHERE (ID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Eesnimi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Eesnimi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Perenimi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Perenimi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Aine" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Aine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne1" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne2" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne3" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne4" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne5" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne6" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne6" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne7" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne7" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne8" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne9" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne10" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne10" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Eesnimi, Perenimi, Aine, Hinne1, Hinne2, Hinne3, Hinne4, Hinne5, Hinne6, Hinne7, Hinne8, Hinne9, Hinne10, Kokku, ID FROM dbo.Hinne</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Hinne] SET [Eesnimi] = @Eesnimi, [Perenimi] = @Perenimi, [Aine] = @Aine, [Hinne1] = @Hinne1, [Hinne2] = @Hinne2, [Hinne3] = @Hinne3, [Hinne4] = @Hinne4, [Hinne5] = @Hinne5, [Hinne6] = @Hinne6, [Hinne7] = @Hinne7, [Hinne8] = @Hinne8, [Hinne9] = @Hinne9, [Hinne10] = @Hinne10 WHERE (((@IsNull_Eesnimi = 1 AND [Eesnimi] IS NULL) OR ([Eesnimi] = @Original_Eesnimi)) AND ((@IsNull_Perenimi = 1 AND [Perenimi] IS NULL) OR ([Perenimi] = @Original_Perenimi)) AND ((@IsNull_Aine = 1 AND [Aine] IS NULL) OR ([Aine] = @Original_Aine)) AND ((@IsNull_Hinne1 = 1 AND [Hinne1] IS NULL) OR ([Hinne1] = @Original_Hinne1)) AND ((@IsNull_Hinne2 = 1 AND [Hinne2] IS NULL) OR ([Hinne2] = @Original_Hinne2)) AND ((@IsNull_Hinne3 = 1 AND [Hinne3] IS NULL) OR ([Hinne3] = @Original_Hinne3)) AND ((@IsNull_Hinne4 = 1 AND [Hinne4] IS NULL) OR ([Hinne4] = @Original_Hinne4)) AND ((@IsNull_Hinne5 = 1 AND [Hinne5] IS NULL) OR ([Hinne5] = @Original_Hinne5)) AND ((@IsNull_Hinne6 = 1 AND [Hinne6] IS NULL) OR ([Hinne6] = @Original_Hinne6)) AND ((@IsNull_Hinne7 = 1 AND [Hinne7] IS NULL) OR ([Hinne7] = @Original_Hinne7)) AND ((@IsNull_Hinne8 = 1 AND [Hinne8] IS NULL) OR ([Hinne8] = @Original_Hinne8)) AND ((@IsNull_Hinne9 = 1 AND [Hinne9] IS NULL) OR ([Hinne9] = @Original_Hinne9)) AND ((@IsNull_Hinne10 = 1 AND [Hinne10] IS NULL) OR ([Hinne10] = @Original_Hinne10)) AND ((@IsNull_Kokku = 1 AND [Kokku] IS NULL) OR ([Kokku] = @Original_Kokku)) AND ([ID] = @Original_ID));
SELECT Eesnimi, Perenimi, Aine, Hinne1, Hinne2, Hinne3, Hinne4, Hinne5, Hinne6, Hinne7, Hinne8, Hinne9, Hinne10, Kokku, ID FROM Hinne WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Eesnimi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Eesnimi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Perenimi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Perenimi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Aine" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Aine" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne1" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne2" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne3" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne4" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne5" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne5" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne6" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne6" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne7" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne7" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne8" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne9" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne9" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Hinne10" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne10" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Eesnimi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Eesnimi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Eesnimi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Eesnimi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Perenimi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Perenimi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Perenimi" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Perenimi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Aine" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Aine" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Aine" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Aine" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne1" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne2" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne3" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne4" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne5" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne5" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne5" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne6" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne6" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne6" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne6" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne7" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne7" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne7" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne7" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne8" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne8" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne8" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne8" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne9" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne9" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne9" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne9" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hinne10" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hinne10" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Hinne10" Precision="17" ProviderType="Decimal" Scale="1" Size="0" SourceColumn="Hinne10" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Kokku" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kokku" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Kokku" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Kokku" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Eesnimi" DataSetColumn="Eesnimi" />
              <Mapping SourceColumn="Perenimi" DataSetColumn="Perenimi" />
              <Mapping SourceColumn="Aine" DataSetColumn="Aine" />
              <Mapping SourceColumn="Hinne1" DataSetColumn="Hinne1" />
              <Mapping SourceColumn="Hinne2" DataSetColumn="Hinne2" />
              <Mapping SourceColumn="Hinne3" DataSetColumn="Hinne3" />
              <Mapping SourceColumn="Hinne4" DataSetColumn="Hinne4" />
              <Mapping SourceColumn="Hinne5" DataSetColumn="Hinne5" />
              <Mapping SourceColumn="Hinne6" DataSetColumn="Hinne6" />
              <Mapping SourceColumn="Hinne7" DataSetColumn="Hinne7" />
              <Mapping SourceColumn="Hinne8" DataSetColumn="Hinne8" />
              <Mapping SourceColumn="Hinne9" DataSetColumn="Hinne9" />
              <Mapping SourceColumn="Hinne10" DataSetColumn="Hinne10" />
              <Mapping SourceColumn="Kokku" DataSetColumn="Kokku" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DataSet1" msprop:Generator_UserDSName="DataSet1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Lesson" msprop:Generator_TableClassName="LessonDataTable" msprop:Generator_TableVarName="tableLesson" msprop:Generator_TablePropName="Lesson" msprop:Generator_RowDeletingName="LessonRowDeleting" msprop:Generator_UserTableName="Lesson" msprop:Generator_RowChangingName="LessonRowChanging" msprop:Generator_RowEvHandlerName="LessonRowChangeEventHandler" msprop:Generator_RowDeletedName="LessonRowDeleted" msprop:Generator_RowEvArgName="LessonRowChangeEvent" msprop:Generator_RowChangedName="LessonRowChanged" msprop:Generator_RowClassName="LessonRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Lessond_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnLessond_ID" msprop:Generator_ColumnPropNameInRow="Lessond_ID" msprop:Generator_ColumnPropNameInTable="Lessond_IDColumn" msprop:Generator_UserColumnName="Lessond_ID" type="xs:int" />
              <xs:element name="Topic" msprop:Generator_ColumnVarNameInTable="columnTopic" msprop:Generator_ColumnPropNameInRow="Topic" msprop:Generator_ColumnPropNameInTable="TopicColumn" msprop:Generator_UserColumnName="Topic">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Date" msprop:Generator_ColumnVarNameInTable="columnDate" msprop:Generator_ColumnPropNameInRow="Date" msprop:Generator_ColumnPropNameInTable="DateColumn" msprop:Generator_UserColumnName="Date" type="xs:dateTime" />
              <xs:element name="Descripton" msprop:Generator_ColumnVarNameInTable="columnDescripton" msprop:Generator_ColumnPropNameInRow="Descripton" msprop:Generator_ColumnPropNameInTable="DescriptonColumn" msprop:Generator_UserColumnName="Descripton" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_UserColumnName="Comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Subject_ID" msprop:Generator_ColumnVarNameInTable="columnSubject_ID" msprop:Generator_ColumnPropNameInRow="Subject_ID" msprop:Generator_ColumnPropNameInTable="Subject_IDColumn" msprop:Generator_UserColumnName="Subject_ID" type="xs:int" />
              <xs:element name="User_ID" msprop:Generator_ColumnVarNameInTable="columnUser_ID" msprop:Generator_ColumnPropNameInRow="User_ID" msprop:Generator_ColumnPropNameInTable="User_IDColumn" msprop:Generator_UserColumnName="User_ID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Student" msprop:Generator_TableClassName="StudentDataTable" msprop:Generator_TableVarName="tableStudent" msprop:Generator_TablePropName="Student" msprop:Generator_RowDeletingName="StudentRowDeleting" msprop:Generator_UserTableName="Student" msprop:Generator_RowChangingName="StudentRowChanging" msprop:Generator_RowEvHandlerName="StudentRowChangeEventHandler" msprop:Generator_RowDeletedName="StudentRowDeleted" msprop:Generator_RowEvArgName="StudentRowChangeEvent" msprop:Generator_RowChangedName="StudentRowChanged" msprop:Generator_RowClassName="StudentRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Student_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnStudent_ID" msprop:Generator_ColumnPropNameInRow="Student_ID" msprop:Generator_ColumnPropNameInTable="Student_IDColumn" msprop:Generator_UserColumnName="Student_ID" type="xs:int" />
              <xs:element name="firstName" msprop:Generator_ColumnVarNameInTable="columnfirstName" msprop:Generator_ColumnPropNameInRow="firstName" msprop:Generator_ColumnPropNameInTable="firstNameColumn" msprop:Generator_UserColumnName="firstName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lastName" msprop:Generator_ColumnVarNameInTable="columnlastName" msprop:Generator_ColumnPropNameInRow="lastName" msprop:Generator_ColumnPropNameInTable="lastNameColumn" msprop:Generator_UserColumnName="lastName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="speciality" msprop:Generator_ColumnVarNameInTable="columnspeciality" msprop:Generator_ColumnPropNameInRow="speciality" msprop:Generator_ColumnPropNameInTable="specialityColumn" msprop:Generator_UserColumnName="speciality">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="studentGroup" msprop:Generator_ColumnVarNameInTable="columnstudentGroup" msprop:Generator_ColumnPropNameInRow="studentGroup" msprop:Generator_ColumnPropNameInTable="studentGroupColumn" msprop:Generator_UserColumnName="studentGroup">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="identityCode" msprop:Generator_ColumnVarNameInTable="columnidentityCode" msprop:Generator_ColumnPropNameInRow="identityCode" msprop:Generator_ColumnPropNameInTable="identityCodeColumn" msprop:Generator_UserColumnName="identityCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="comment" msprop:Generator_ColumnVarNameInTable="columncomment" msprop:Generator_ColumnPropNameInRow="comment" msprop:Generator_ColumnPropNameInTable="commentColumn" msprop:Generator_UserColumnName="comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_ID" msprop:Generator_ColumnVarNameInTable="columnuser_ID" msprop:Generator_ColumnPropNameInRow="user_ID" msprop:Generator_ColumnPropNameInTable="user_IDColumn" msprop:Generator_UserColumnName="user_ID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Student_In_Lesson" msprop:Generator_TableClassName="Student_In_LessonDataTable" msprop:Generator_TableVarName="tableStudent_In_Lesson" msprop:Generator_TablePropName="Student_In_Lesson" msprop:Generator_RowDeletingName="Student_In_LessonRowDeleting" msprop:Generator_UserTableName="Student_In_Lesson" msprop:Generator_RowChangingName="Student_In_LessonRowChanging" msprop:Generator_RowEvHandlerName="Student_In_LessonRowChangeEventHandler" msprop:Generator_RowDeletedName="Student_In_LessonRowDeleted" msprop:Generator_RowEvArgName="Student_In_LessonRowChangeEvent" msprop:Generator_RowChangedName="Student_In_LessonRowChanged" msprop:Generator_RowClassName="Student_In_LessonRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Student_In_lesson_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnStudent_In_lesson_ID" msprop:Generator_ColumnPropNameInRow="Student_In_lesson_ID" msprop:Generator_ColumnPropNameInTable="Student_In_lesson_IDColumn" msprop:Generator_UserColumnName="Student_In_lesson_ID" type="xs:int" />
              <xs:element name="Student_ID" msprop:Generator_ColumnVarNameInTable="columnStudent_ID" msprop:Generator_ColumnPropNameInRow="Student_ID" msprop:Generator_ColumnPropNameInTable="Student_IDColumn" msprop:Generator_UserColumnName="Student_ID" type="xs:int" />
              <xs:element name="Lesson_ID" msprop:Generator_ColumnVarNameInTable="columnLesson_ID" msprop:Generator_ColumnPropNameInRow="Lesson_ID" msprop:Generator_ColumnPropNameInTable="Lesson_IDColumn" msprop:Generator_UserColumnName="Lesson_ID" type="xs:int" />
              <xs:element name="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_UserColumnName="Comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User_ID" msprop:Generator_ColumnVarNameInTable="columnUser_ID" msprop:Generator_ColumnPropNameInRow="User_ID" msprop:Generator_ColumnPropNameInTable="User_IDColumn" msprop:Generator_UserColumnName="User_ID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Student_In_Subject" msprop:Generator_TableClassName="Student_In_SubjectDataTable" msprop:Generator_TableVarName="tableStudent_In_Subject" msprop:Generator_TablePropName="Student_In_Subject" msprop:Generator_RowDeletingName="Student_In_SubjectRowDeleting" msprop:Generator_UserTableName="Student_In_Subject" msprop:Generator_RowChangingName="Student_In_SubjectRowChanging" msprop:Generator_RowEvHandlerName="Student_In_SubjectRowChangeEventHandler" msprop:Generator_RowDeletedName="Student_In_SubjectRowDeleted" msprop:Generator_RowEvArgName="Student_In_SubjectRowChangeEvent" msprop:Generator_RowChangedName="Student_In_SubjectRowChanged" msprop:Generator_RowClassName="Student_In_SubjectRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Student_In_Subject" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnStudent_In_Subject" msprop:Generator_ColumnPropNameInRow="Student_In_Subject" msprop:Generator_ColumnPropNameInTable="Student_In_SubjectColumn" msprop:Generator_UserColumnName="Student_In_Subject" type="xs:int" />
              <xs:element name="Student_ID" msprop:Generator_ColumnVarNameInTable="columnStudent_ID" msprop:Generator_ColumnPropNameInRow="Student_ID" msprop:Generator_ColumnPropNameInTable="Student_IDColumn" msprop:Generator_UserColumnName="Student_ID" type="xs:int" />
              <xs:element name="Subject_ID" msprop:Generator_ColumnVarNameInTable="columnSubject_ID" msprop:Generator_ColumnPropNameInRow="Subject_ID" msprop:Generator_ColumnPropNameInTable="Subject_IDColumn" msprop:Generator_UserColumnName="Subject_ID" type="xs:int" />
              <xs:element name="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_UserColumnName="Comment">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User_ID" msprop:Generator_ColumnVarNameInTable="columnUser_ID" msprop:Generator_ColumnPropNameInRow="User_ID" msprop:Generator_ColumnPropNameInTable="User_IDColumn" msprop:Generator_UserColumnName="User_ID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Subject" msprop:Generator_TableClassName="SubjectDataTable" msprop:Generator_TableVarName="tableSubject" msprop:Generator_TablePropName="Subject" msprop:Generator_RowDeletingName="SubjectRowDeleting" msprop:Generator_UserTableName="Subject" msprop:Generator_RowChangingName="SubjectRowChanging" msprop:Generator_RowEvHandlerName="SubjectRowChangeEventHandler" msprop:Generator_RowDeletedName="SubjectRowDeleted" msprop:Generator_RowEvArgName="SubjectRowChangeEvent" msprop:Generator_RowChangedName="SubjectRowChanged" msprop:Generator_RowClassName="SubjectRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Subject_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnSubject_ID" msprop:Generator_ColumnPropNameInRow="Subject_ID" msprop:Generator_ColumnPropNameInTable="Subject_IDColumn" msprop:Generator_UserColumnName="Subject_ID" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EAP" msprop:Generator_ColumnVarNameInTable="columnEAP" msprop:Generator_ColumnPropNameInRow="EAP" msprop:Generator_ColumnPropNameInTable="EAPColumn" msprop:Generator_UserColumnName="EAP" type="xs:decimal" />
              <xs:element name="SubjectCode" msprop:Generator_ColumnVarNameInTable="columnSubjectCode" msprop:Generator_ColumnPropNameInRow="SubjectCode" msprop:Generator_ColumnPropNameInTable="SubjectCodeColumn" msprop:Generator_UserColumnName="SubjectCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Language" msprop:Generator_ColumnVarNameInTable="columnLanguage" msprop:Generator_ColumnPropNameInRow="Language" msprop:Generator_ColumnPropNameInTable="LanguageColumn" msprop:Generator_UserColumnName="Language">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_UserColumnName="Comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="User_ID" msprop:Generator_ColumnVarNameInTable="columnUser_ID" msprop:Generator_ColumnPropNameInRow="User_ID" msprop:Generator_ColumnPropNameInTable="User_IDColumn" msprop:Generator_UserColumnName="User_ID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="User" msprop:Generator_TableClassName="UserDataTable" msprop:Generator_TableVarName="tableUser" msprop:Generator_TablePropName="User" msprop:Generator_RowDeletingName="UserRowDeleting" msprop:Generator_UserTableName="User" msprop:Generator_RowChangingName="UserRowChanging" msprop:Generator_RowEvHandlerName="UserRowChangeEventHandler" msprop:Generator_RowDeletedName="UserRowDeleted" msprop:Generator_RowEvArgName="UserRowChangeEvent" msprop:Generator_RowChangedName="UserRowChanged" msprop:Generator_RowClassName="UserRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="User_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnUser_ID" msprop:Generator_ColumnPropNameInRow="User_ID" msprop:Generator_ColumnPropNameInTable="User_IDColumn" msprop:Generator_UserColumnName="User_ID" type="xs:int" />
              <xs:element name="firstName" msprop:Generator_ColumnVarNameInTable="columnfirstName" msprop:Generator_ColumnPropNameInRow="firstName" msprop:Generator_ColumnPropNameInTable="firstNameColumn" msprop:Generator_UserColumnName="firstName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lastName" msprop:Generator_ColumnVarNameInTable="columnlastName" msprop:Generator_ColumnPropNameInRow="lastName" msprop:Generator_ColumnPropNameInTable="lastNameColumn" msprop:Generator_UserColumnName="lastName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="userName" msprop:Generator_ColumnVarNameInTable="columnuserName" msprop:Generator_ColumnPropNameInRow="userName" msprop:Generator_ColumnPropNameInTable="userNameColumn" msprop:Generator_UserColumnName="userName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tund" msprop:Generator_TableClassName="TundDataTable" msprop:Generator_TableVarName="tableTund" msprop:Generator_TablePropName="Tund" msprop:Generator_RowDeletingName="TundRowDeleting" msprop:Generator_UserTableName="Tund" msprop:Generator_RowChangingName="TundRowChanging" msprop:Generator_RowEvHandlerName="TundRowChangeEventHandler" msprop:Generator_RowDeletedName="TundRowDeleted" msprop:Generator_RowEvArgName="TundRowChangeEvent" msprop:Generator_RowChangedName="TundRowChanged" msprop:Generator_RowClassName="TundRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Tund_ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnTund_ID" msprop:Generator_ColumnPropNameInRow="Tund_ID" msprop:Generator_ColumnPropNameInTable="Tund_IDColumn" msprop:Generator_UserColumnName="Tund_ID" type="xs:int" />
              <xs:element name="Aine" msprop:Generator_ColumnVarNameInTable="columnAine" msprop:Generator_ColumnPropNameInRow="Aine" msprop:Generator_ColumnPropNameInTable="AineColumn" msprop:Generator_UserColumnName="Aine" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Teema" msprop:Generator_ColumnVarNameInTable="columnTeema" msprop:Generator_ColumnPropNameInRow="Teema" msprop:Generator_ColumnPropNameInTable="TeemaColumn" msprop:Generator_UserColumnName="Teema" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Kirjeldus" msprop:Generator_ColumnVarNameInTable="columnKirjeldus" msprop:Generator_ColumnPropNameInRow="Kirjeldus" msprop:Generator_ColumnPropNameInTable="KirjeldusColumn" msprop:Generator_UserColumnName="Kirjeldus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Kommentaar" msprop:Generator_ColumnVarNameInTable="columnKommentaar" msprop:Generator_ColumnPropNameInRow="Kommentaar" msprop:Generator_ColumnPropNameInTable="KommentaarColumn" msprop:Generator_UserColumnName="Kommentaar" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Kuupäev" msprop:Generator_ColumnVarNameInTable="columnKuupäev" msprop:Generator_ColumnPropNameInRow="Kuupäev" msprop:Generator_ColumnPropNameInTable="KuupäevColumn" msprop:Generator_UserColumnName="Kuupäev" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Hinne" msprop:Generator_TableClassName="HinneDataTable" msprop:Generator_TableVarName="tableHinne" msprop:Generator_TablePropName="Hinne" msprop:Generator_RowDeletingName="HinneRowDeleting" msprop:Generator_UserTableName="Hinne" msprop:Generator_RowChangingName="HinneRowChanging" msprop:Generator_RowEvHandlerName="HinneRowChangeEventHandler" msprop:Generator_RowDeletedName="HinneRowDeleted" msprop:Generator_RowEvArgName="HinneRowChangeEvent" msprop:Generator_RowChangedName="HinneRowChanged" msprop:Generator_RowClassName="HinneRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Eesnimi" msprop:Generator_ColumnVarNameInTable="columnEesnimi" msprop:Generator_ColumnPropNameInRow="Eesnimi" msprop:Generator_ColumnPropNameInTable="EesnimiColumn" msprop:Generator_UserColumnName="Eesnimi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Perenimi" msprop:Generator_ColumnVarNameInTable="columnPerenimi" msprop:Generator_ColumnPropNameInRow="Perenimi" msprop:Generator_ColumnPropNameInTable="PerenimiColumn" msprop:Generator_UserColumnName="Perenimi" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Aine" msprop:Generator_ColumnVarNameInTable="columnAine" msprop:Generator_ColumnPropNameInRow="Aine" msprop:Generator_ColumnPropNameInTable="AineColumn" msprop:Generator_UserColumnName="Aine" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Hinne1" msprop:Generator_ColumnVarNameInTable="columnHinne1" msprop:Generator_ColumnPropNameInRow="Hinne1" msprop:Generator_ColumnPropNameInTable="Hinne1Column" msprop:Generator_UserColumnName="Hinne1" type="xs:decimal" minOccurs="0" />
              <xs:element name="Hinne2" msprop:Generator_ColumnVarNameInTable="columnHinne2" msprop:Generator_ColumnPropNameInRow="Hinne2" msprop:Generator_ColumnPropNameInTable="Hinne2Column" msprop:Generator_UserColumnName="Hinne2" type="xs:decimal" minOccurs="0" />
              <xs:element name="Hinne3" msprop:Generator_ColumnVarNameInTable="columnHinne3" msprop:Generator_ColumnPropNameInRow="Hinne3" msprop:Generator_ColumnPropNameInTable="Hinne3Column" msprop:Generator_UserColumnName="Hinne3" type="xs:decimal" minOccurs="0" />
              <xs:element name="Hinne4" msprop:Generator_ColumnVarNameInTable="columnHinne4" msprop:Generator_ColumnPropNameInRow="Hinne4" msprop:Generator_ColumnPropNameInTable="Hinne4Column" msprop:Generator_UserColumnName="Hinne4" type="xs:decimal" minOccurs="0" />
              <xs:element name="Hinne5" msprop:Generator_ColumnVarNameInTable="columnHinne5" msprop:Generator_ColumnPropNameInRow="Hinne5" msprop:Generator_ColumnPropNameInTable="Hinne5Column" msprop:Generator_UserColumnName="Hinne5" type="xs:decimal" minOccurs="0" />
              <xs:element name="Hinne6" msprop:Generator_ColumnVarNameInTable="columnHinne6" msprop:Generator_ColumnPropNameInRow="Hinne6" msprop:Generator_ColumnPropNameInTable="Hinne6Column" msprop:Generator_UserColumnName="Hinne6" type="xs:decimal" minOccurs="0" />
              <xs:element name="Hinne7" msprop:Generator_ColumnVarNameInTable="columnHinne7" msprop:Generator_ColumnPropNameInRow="Hinne7" msprop:Generator_ColumnPropNameInTable="Hinne7Column" msprop:Generator_UserColumnName="Hinne7" type="xs:decimal" minOccurs="0" />
              <xs:element name="Hinne8" msprop:Generator_ColumnVarNameInTable="columnHinne8" msprop:Generator_ColumnPropNameInRow="Hinne8" msprop:Generator_ColumnPropNameInTable="Hinne8Column" msprop:Generator_UserColumnName="Hinne8" type="xs:decimal" minOccurs="0" />
              <xs:element name="Hinne9" msprop:Generator_ColumnVarNameInTable="columnHinne9" msprop:Generator_ColumnPropNameInRow="Hinne9" msprop:Generator_ColumnPropNameInTable="Hinne9Column" msprop:Generator_UserColumnName="Hinne9" type="xs:decimal" minOccurs="0" />
              <xs:element name="Hinne10" msprop:Generator_ColumnVarNameInTable="columnHinne10" msprop:Generator_ColumnPropNameInRow="Hinne10" msprop:Generator_ColumnPropNameInTable="Hinne10Column" msprop:Generator_UserColumnName="Hinne10" type="xs:decimal" minOccurs="0" />
              <xs:element name="Kokku" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnKokku" msprop:Generator_ColumnPropNameInRow="Kokku" msprop:Generator_ColumnPropNameInTable="KokkuColumn" msprop:Generator_UserColumnName="Kokku" type="xs:int" minOccurs="0" />
              <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Lesson" />
      <xs:field xpath="mstns:Lessond_ID" />
    </xs:unique>
    <xs:unique name="Student_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Student" />
      <xs:field xpath="mstns:Student_ID" />
    </xs:unique>
    <xs:unique name="Student_In_Lesson_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Student_In_Lesson" />
      <xs:field xpath="mstns:Student_In_lesson_ID" />
    </xs:unique>
    <xs:unique name="Student_In_Subject_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Student_In_Subject" />
      <xs:field xpath="mstns:Student_In_Subject" />
    </xs:unique>
    <xs:unique name="Subject_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Subject" />
      <xs:field xpath="mstns:Subject_ID" />
    </xs:unique>
    <xs:unique name="User_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:User" />
      <xs:field xpath="mstns:User_ID" />
    </xs:unique>
    <xs:unique name="Tund_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tund" />
      <xs:field xpath="mstns:Tund_ID" />
    </xs:unique>
    <xs:unique name="Hinne_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Hinne" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Student_In_Lesson_Lesson" msdata:parent="Lesson" msdata:child="Student_In_Lesson" msdata:parentkey="Lessond_ID" msdata:childkey="Lesson_ID" msprop:Generator_UserChildTable="Student_In_Lesson" msprop:Generator_ChildPropName="GetStudent_In_LessonRows" msprop:Generator_ParentPropName="LessonRow" msprop:Generator_UserRelationName="FK_Student_In_Lesson_Lesson" msprop:Generator_RelationVarName="relationFK_Student_In_Lesson_Lesson" msprop:Generator_UserParentTable="Lesson" />
      <msdata:Relationship name="FK_Student_In_Lesson_Student" msdata:parent="Student" msdata:child="Student_In_Lesson" msdata:parentkey="Student_ID" msdata:childkey="Student_ID" msprop:Generator_UserChildTable="Student_In_Lesson" msprop:Generator_ChildPropName="GetStudent_In_LessonRows" msprop:Generator_ParentPropName="StudentRow" msprop:Generator_UserRelationName="FK_Student_In_Lesson_Student" msprop:Generator_RelationVarName="relationFK_Student_In_Lesson_Student" msprop:Generator_UserParentTable="Student" />
      <msdata:Relationship name="FK_Student_In_Subject_Student" msdata:parent="Student" msdata:child="Student_In_Subject" msdata:parentkey="Student_ID" msdata:childkey="Student_ID" msprop:Generator_UserChildTable="Student_In_Subject" msprop:Generator_ChildPropName="GetStudent_In_SubjectRows" msprop:Generator_ParentPropName="StudentRow" msprop:Generator_UserRelationName="FK_Student_In_Subject_Student" msprop:Generator_RelationVarName="relationFK_Student_In_Subject_Student" msprop:Generator_UserParentTable="Student" />
      <msdata:Relationship name="FK_Lesson_Subject" msdata:parent="Subject" msdata:child="Lesson" msdata:parentkey="Subject_ID" msdata:childkey="Subject_ID" msprop:Generator_UserChildTable="Lesson" msprop:Generator_ChildPropName="GetLessonRows" msprop:Generator_ParentPropName="SubjectRow" msprop:Generator_UserRelationName="FK_Lesson_Subject" msprop:Generator_RelationVarName="relationFK_Lesson_Subject" msprop:Generator_UserParentTable="Subject" />
      <msdata:Relationship name="FK_Student_In_Subject_Subject" msdata:parent="Subject" msdata:child="Student_In_Subject" msdata:parentkey="Subject_ID" msdata:childkey="Subject_ID" msprop:Generator_UserChildTable="Student_In_Subject" msprop:Generator_ChildPropName="GetStudent_In_SubjectRows" msprop:Generator_ParentPropName="SubjectRow" msprop:Generator_UserRelationName="FK_Student_In_Subject_Subject" msprop:Generator_RelationVarName="relationFK_Student_In_Subject_Subject" msprop:Generator_UserParentTable="Subject" />
      <msdata:Relationship name="FK_Lesson_User" msdata:parent="User" msdata:child="Lesson" msdata:parentkey="User_ID" msdata:childkey="User_ID" msprop:Generator_UserChildTable="Lesson" msprop:Generator_ChildPropName="GetLessonRows" msprop:Generator_ParentPropName="UserRow" msprop:Generator_UserRelationName="FK_Lesson_User" msprop:Generator_RelationVarName="relationFK_Lesson_User" msprop:Generator_UserParentTable="User" />
      <msdata:Relationship name="FK_Student_User" msdata:parent="User" msdata:child="Student" msdata:parentkey="User_ID" msdata:childkey="user_ID" msprop:Generator_UserChildTable="Student" msprop:Generator_ChildPropName="GetStudentRows" msprop:Generator_ParentPropName="UserRow" msprop:Generator_UserRelationName="FK_Student_User" msprop:Generator_RelationVarName="relationFK_Student_User" msprop:Generator_UserParentTable="User" />
      <msdata:Relationship name="FK_Student_In_Lesson_User" msdata:parent="User" msdata:child="Student_In_Lesson" msdata:parentkey="User_ID" msdata:childkey="User_ID" msprop:Generator_UserChildTable="Student_In_Lesson" msprop:Generator_ChildPropName="GetStudent_In_LessonRows" msprop:Generator_ParentPropName="UserRow" msprop:Generator_UserRelationName="FK_Student_In_Lesson_User" msprop:Generator_RelationVarName="relationFK_Student_In_Lesson_User" msprop:Generator_UserParentTable="User" />
      <msdata:Relationship name="FK_Student_In_Subject_User" msdata:parent="User" msdata:child="Student_In_Subject" msdata:parentkey="User_ID" msdata:childkey="User_ID" msprop:Generator_UserChildTable="Student_In_Subject" msprop:Generator_ChildPropName="GetStudent_In_SubjectRows" msprop:Generator_ParentPropName="UserRow" msprop:Generator_UserRelationName="FK_Student_In_Subject_User" msprop:Generator_RelationVarName="relationFK_Student_In_Subject_User" msprop:Generator_UserParentTable="User" />
      <msdata:Relationship name="FK_Subject_User" msdata:parent="User" msdata:child="Subject" msdata:parentkey="User_ID" msdata:childkey="User_ID" msprop:Generator_UserChildTable="Subject" msprop:Generator_ChildPropName="GetSubjectRows" msprop:Generator_ParentPropName="UserRow" msprop:Generator_UserRelationName="FK_Subject_User" msprop:Generator_RelationVarName="relationFK_Subject_User" msprop:Generator_UserParentTable="User" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>